In [16]:
import pandas as pd
import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt
In [17]:
data = pd.read_csv(r'D:\Desktop\APLIKACJE\studia\licencjat\projekt\results.csv')
In [63]:
def scatter_plt(data, funds):
    sns.set_style('darkgrid')
    plt.figure(figsize= (12,8))
    data = data[data['funds_name'] == funds]
    title = data['algorithms'].values[0] + ' ' + data['funds_name'].values[0]
    sns.scatterplot(y= 'value', x = 't', hue= 'outlier', data = data, s= 70)
    sns.lineplot(y= 'value', x = 't', data = data)
    plt.title(title)
    plt.show()
In [64]:
def box_plots(data, funds):
    sns.set_style('darkgrid')
    plt.figure(figsize= (12,8))
    data = data[data['funds_name'] == funds]
    data['year'] = data['Data'].astype(str).str[:4]
    title = data['algorithms'].values[0] + ' ' + data['funds_name'].values[0]
    sns.boxplot(y= 'value', x = 'year', data = data, color="skyblue")
    plt.title(title)
    plt.show()

Ramka danych zawierająca wyniki działania modelu

kolumny:

  • funds_name: nazwa funduszu
  • rq: wartość stosunku odchylenie ćwiartkowego do mediany, bÄ™dÄ…ca wyznacznikiem tego jaki algorytm zostanie użyty
  • algorithms: nazwa użytego algorytmu
  • Data: data w do której odnosi siÄ™ wartość obserwacji
  • value: wartość obserwacji
  • cluster, cluster_center, diff, mean_diff, std_diff,critical_value: dotyczÄ… modeli wykonanych za pomoca algorytmu k-Å›rednich
  • outlier: zmienna informujÄ…ca czy obserwacja jest obserwacjÄ… odstajÄ…cÄ…
  • t: tożsama z Data, numer okresu do którego odnosi siÄ™ wartość obserwacji
In [65]:
data.head().iloc[:,1 :-1]
Out[65]:
funds_name rq algorithms Data value cluster cluster_center diff mean_diff std_diff critical_value outlier t
0 Pekao Zrównowa¿ony kat. A (PLN) 0.151192 if_results 1992-07-28 10.00 NaN NaN NaN NaN NaN NaN True 0
1 Pekao Zrównowa¿ony kat. A (PLN) 0.151192 if_results 1992-07-29 10.00 NaN NaN NaN NaN NaN NaN True 1
2 Pekao Zrównowa¿ony kat. A (PLN) 0.151192 if_results 1992-07-30 10.00 NaN NaN NaN NaN NaN NaN True 2
3 Pekao Zrównowa¿ony kat. A (PLN) 0.151192 if_results 1992-08-06 10.06 NaN NaN NaN NaN NaN NaN True 3
4 Pekao Zrównowa¿ony kat. A (PLN) 0.151192 if_results 1992-08-13 10.12 NaN NaN NaN NaN NaN NaN True 4

Wymiary tablicy:

In [66]:
data.shape
Out[66]:
(250392, 15)

Statystyki dla danego funduszu:

In [67]:
data.groupby('funds_name')['value'].describe().iloc[:30]
Out[67]:
count mean std min 25% 50% 75% max
funds_name
Pekao Akcji ? Aktywna Selekcja kat. A (PLN) 2291.0 9.988542 0.995265 7.39 9.280 10.090 10.7650 11.92
Pekao Akcji ? Aktywna Selekcja kat. E (PLN) 1303.0 10.126086 0.872790 8.08 9.560 10.130 10.8400 11.92
Pekao Akcji ? Aktywna Selekcja kat. I (PLN) 2291.0 10.037682 1.016492 7.39 9.285 10.220 10.7900 11.99
Pekao Akcji Amerykañskich kat. A (PLN) 4939.0 77.889617 23.077363 36.97 61.160 69.110 98.9350 141.86
Pekao Akcji Amerykañskich kat. A (USD) 4102.0 23.229612 5.095693 10.90 19.530 22.195 27.1475 35.80
Pekao Akcji Amerykañskich kat. E (PLN) 4482.0 83.155518 28.236704 39.37 62.690 71.265 111.8275 160.45
Pekao Akcji Amerykañskich kat. I (PLN) 4481.0 89.577710 32.744984 41.65 65.550 75.070 122.6400 179.59
Pekao Akcji Amerykañskich kat. I (USD) 4102.0 27.256451 7.224226 12.36 21.570 25.060 32.8400 45.33
Pekao Akcji Europejskich kat. A (EUR) 3965.0 9.785367 1.815078 4.90 8.340 10.210 11.3200 12.91
Pekao Akcji Europejskich kat. A (PLN) 3965.0 40.329190 7.958742 20.99 33.550 40.920 47.3500 53.89
Pekao Akcji Europejskich kat. I (EUR) 3965.0 10.769526 2.300493 5.22 8.830 10.880 12.6900 14.99
Pekao Akcji Europejskich kat. I (PLN) 3965.0 44.456835 10.326888 22.26 36.190 43.250 54.5100 64.06
Pekao Akcji Ma³ych i ¦rednich Spó³ek Rynków Rozwiniêtych (PLN) 3222.0 9.300956 2.443927 3.90 7.350 9.775 11.5975 13.28
Pekao Akcji Polskich kat. A (PLN) 6055.0 25.963582 10.039501 9.93 19.980 22.540 29.3100 67.63
Pekao Akcji Polskich kat. E (PLN) 4482.0 30.780535 10.695713 16.68 24.400 27.040 35.3500 71.28
Pekao Akcji Polskich kat. I (PLN) 4481.0 29.249310 9.667224 16.63 23.430 26.030 33.2000 66.41
Pekao Akcji Rynków Dalekiego Wschodu (PLN) 3184.0 8.783851 1.262803 5.10 8.040 8.735 9.5525 12.16
Pekao Akcji Rynków Wschodz±cych (PLN) 3247.0 7.924155 1.802612 4.24 6.860 7.600 8.2700 14.09
Pekao Alternatywny - Absolutnej Stopy Zwrotu (PLN) 1171.0 10.419991 0.337187 9.54 10.210 10.500 10.6800 11.12
Pekao Alternatywny - Globalnego Dochodu (PLN) 1255.0 10.228175 0.440702 9.01 9.870 10.320 10.5500 11.26
Pekao Alternatywny Dynamiczny Absolutnej Stopy Zwrotu (PLN) 485.0 10.093835 0.188629 9.77 9.990 10.050 10.2300 10.61
Pekao Dochodu USD (PLN) 943.0 10.096341 0.547242 8.83 9.740 10.050 10.5200 11.29
Pekao Dochodu USD (USD) 943.0 2.668006 0.077555 2.54 2.600 2.660 2.7100 2.85
Pekao Dochodu i Wzrostu Regionu Pacyfiku (PLN) 3416.0 13.079116 2.046849 7.74 11.570 13.065 14.6700 17.63
Pekao Dochodu i Wzrostu Rynku Chiñskiego (PLN) 3456.0 14.169812 2.642908 8.02 12.240 14.125 16.2025 19.64
Pekao Dynamicznych Spó³ek kat. A (PLN) 2018.0 17.216001 2.678338 10.02 16.400 17.350 18.8900 21.85
Pekao Dynamicznych Spó³ek kat. E (PLN) 1303.0 18.551174 1.690459 15.52 17.140 18.290 19.7750 21.85
Pekao Dynamicznych Spó³ek kat. I (PLN) 2018.0 17.934083 3.058406 10.02 17.050 18.140 19.7375 23.06
Pekao Kompas (PLN) 2122.0 11.357375 0.592890 9.90 11.020 11.320 11.8300 12.53
Pekao Konserwatywny Plus kat. A (PLN) 1607.0 10.787007 0.411800 10.00 10.510 10.730 11.1300 11.60
In [68]:
data.groupby('funds_name')['value'].describe().iloc[30:60]
Out[68]:
count mean std min 25% 50% 75% max
funds_name
Pekao Konserwatywny Plus kat. E (PLN) 1607.0 10.787007 0.411800 10.00 10.5100 10.730 11.1300 11.60
Pekao Konserwatywny Plus kat. I (PLN) 1607.0 10.855358 0.454170 10.00 10.5500 10.800 11.2400 11.75
Pekao Konserwatywny kat. A (PLN) 4619.0 157.820377 28.476186 100.62 133.8000 159.650 184.9000 200.44
Pekao Konserwatywny kat. E (PLN) 1303.0 190.897974 4.983580 183.68 186.3900 189.920 195.1300 200.44
Pekao Konserwatywny kat. I (PLN) 4373.0 160.707821 26.446148 111.65 136.9200 162.660 185.3500 200.44
Pekao Ma³ych i ¦rednich Spó³ek Rynku Polskiego kat. A (PLN) 3652.0 10.869425 3.976763 5.57 8.8800 9.800 11.3000 27.84
Pekao Ma³ych i ¦rednich Spó³ek Rynku Polskiego kat. E (PLN) 1303.0 9.728434 0.848286 8.14 9.0800 9.570 10.3700 11.44
Pekao Ma³ych i ¦rednich Spó³ek Rynku Polskiego kat. I (PLN) 3652.0 10.768217 3.526622 5.26 9.1975 10.180 11.3600 25.85
Pekao Megatrendy (PLN) 178.0 10.398764 0.345397 9.87 10.1500 10.285 10.6200 11.23
Pekao Megatrendy kat. E (PLN) 178.0 10.398764 0.345397 9.87 10.1500 10.285 10.6200 11.23
Pekao Megatrendy kat. I (PLN) 178.0 10.399213 0.346419 9.87 10.1500 10.285 10.6200 11.24
Pekao Obligacji ? Dynamiczna Alokacja 2 kat. A (PLN) 1904.0 11.603624 0.798134 10.01 10.9875 11.700 12.2000 12.98
Pekao Obligacji ? Dynamiczna Alokacja 2 kat. E (PLN) 1904.0 11.603624 0.798134 10.01 10.9875 11.700 12.2000 12.98
Pekao Obligacji ? Dynamiczna Alokacja 2 kat. I (PLN) 1904.0 11.742489 0.882801 10.01 11.0475 11.850 12.4200 13.28
Pekao Obligacji ? Dynamiczna Alokacja FIO kat. A (PLN) 2475.0 128.495034 14.147634 100.08 117.8850 133.220 138.6650 150.98
Pekao Obligacji ? Dynamiczna Alokacja FIO kat. E (PLN) 2475.0 128.495034 14.147634 100.08 117.8850 133.220 138.6650 150.98
Pekao Obligacji ? Dynamiczna Alokacja FIO kat. I (PLN) 2475.0 128.495034 14.147634 100.08 117.8850 133.220 138.6650 150.98
Pekao Obligacji Dolarowych Plus kat. A (PLN) 4464.0 55.297368 14.870659 26.00 42.6200 51.005 71.1900 84.03
Pekao Obligacji Dolarowych Plus kat. A (USD) 4402.0 16.465298 3.304164 9.13 13.5100 17.610 19.5100 21.21
Pekao Obligacji Dolarowych Plus kat. I (PLN) 4006.0 56.598325 15.125874 26.00 43.0200 58.325 72.0175 84.03
Pekao Obligacji Dolarowych Plus kat. I (USD) 4006.0 16.970854 3.010709 9.13 14.0900 18.180 19.5800 21.21
Pekao Obligacji Europejskich Plus kat. A (EUR) 4190.0 9.757823 0.694980 7.12 9.3000 9.590 10.4100 10.86
Pekao Obligacji Europejskich Plus kat. A (PLN) 4190.0 40.498043 4.187167 28.76 37.2800 41.185 44.0000 47.96
Pekao Obligacji Europejskich Plus kat. I (EUR) 3985.0 9.798620 0.687772 7.12 9.3500 9.680 10.4300 10.86
Pekao Obligacji Europejskich Plus kat. I (PLN) 4006.0 40.483752 4.268943 28.76 37.1800 41.255 44.0700 47.96
Pekao Obligacji Plus kat. A (PLN) 6185.0 38.007447 15.260609 10.00 25.2800 37.600 52.9000 61.56
Pekao Obligacji Plus kat. E (PLN) 4373.0 45.931470 10.149763 28.91 36.6000 46.420 55.5700 61.56
Pekao Obligacji Plus kat. I (PLN) 4373.0 45.931470 10.149763 28.91 36.6000 46.420 55.5700 61.56
Pekao Obligacji Samorz±dowych (PLN) 56.0 100.262500 0.204977 100.00 100.0500 100.270 100.4250 100.62
Pekao Obligacji Strategicznych (PLN) 3086.0 15.238211 3.239921 7.19 13.3500 16.480 17.8700 19.35
In [69]:
data.groupby('funds_name')['value'].describe().iloc[60:]
Out[69]:
count mean std min 25% 50% 75% max
funds_name
Pekao Obligacji i Dochodu (PLN) 1404.0 11.083561 0.648749 9.72 10.4400 11.280 11.6200 12.30
Pekao PPK 2020 Spokojne Jutro kat. A (PLN) 44.0 10.003636 0.005323 10.00 10.0000 10.000 10.0100 10.02
Pekao PPK 2025 (PLN) 55.0 10.067091 0.064569 10.00 10.0200 10.050 10.0850 10.19
Pekao PPK 2030 (PLN) 55.0 10.086000 0.089971 10.00 10.0200 10.050 10.1100 10.27
Pekao PPK 2035 (PLN) 55.0 10.099091 0.113109 10.00 10.0200 10.050 10.1200 10.34
Pekao PPK 2040 (PLN) 55.0 10.115818 0.129482 10.00 10.0200 10.070 10.1400 10.39
Pekao PPK 2045 (PLN) 55.0 10.120909 0.138327 10.00 10.0200 10.070 10.1450 10.41
Pekao PPK 2050 (PLN) 55.0 10.104909 0.132258 10.00 10.0200 10.040 10.1250 10.39
Pekao PPK 2055 (PLN) 55.0 10.091455 0.129077 10.00 10.0100 10.020 10.1000 10.37
Pekao PPK 2060 (PLN) 51.0 10.047647 0.075937 9.97 10.0000 10.010 10.0950 10.22
Pekao Spokojna Inwestycja (PLN) 2547.0 11.595603 0.806180 10.00 10.9400 11.800 12.2200 12.82
Pekao Stabilnego Inwestowania kat. A (PLN) 1912.0 11.651627 0.531629 9.86 11.3200 11.820 12.0400 12.50
Pekao Stabilnego Inwestowania kat. E (PLN) 1912.0 11.651627 0.531629 9.86 11.3200 11.820 12.0400 12.50
Pekao Stabilnego Inwestowania kat. I (PLN) 1912.0 12.103232 0.723958 9.86 11.7400 12.270 12.7000 13.12
Pekao Stabilnego Wzrostu kat. A (PLN) 5867.0 179.281324 32.641555 96.34 157.2600 187.710 199.8400 251.16
Pekao Stabilnego Wzrostu kat. E (PLN) 4481.0 193.805492 19.906024 144.16 182.5600 194.480 204.4500 251.16
Pekao Stabilnego Wzrostu kat. I (PLN) 4475.0 209.813106 23.668350 144.67 197.0600 214.820 226.3300 263.66
Pekao Strategii Globalnej - dynamiczny (PLN) 754.0 10.650942 0.468553 9.43 10.2600 10.655 10.8900 12.00
Pekao Strategii Globalnej - konserwatywny (PLN) 1104.0 11.055507 0.604751 9.86 10.6300 11.070 11.3700 12.50
Pekao Strategii Globalnej kat. A (PLN) 2840.0 16.157838 3.131362 9.93 13.1300 16.905 18.8400 21.92
Pekao Surowców i Energii (PLN) 2907.0 7.091610 1.322930 5.04 5.8450 6.920 8.1800 10.04
Pekao Wzrostu i Dochodu Rynku Amerykañskiego (PLN) 1277.0 10.898387 0.612321 9.56 10.2900 11.050 11.3900 12.39
Pekao Wzrostu i Dochodu Rynku Europejskiego (PLN) 1559.0 11.301405 0.632776 9.97 10.7800 11.410 11.8300 12.71
Pekao Zmiennej Alokacji (PLN) 2715.0 12.327297 0.648934 9.93 12.0900 12.560 12.7800 13.12
Pekao Zmiennej Alokacji Rynku Amerykañskiego (PLN) 2023.0 12.345309 0.972522 9.99 11.8200 12.710 13.0900 13.56
Pekao Zrównowa¿ony Rynku Amerykañskiego kat. A (PLN) 3652.0 39.280208 11.788060 18.96 28.5800 36.930 51.4600 63.37
Pekao Zrównowa¿ony Rynku Amerykañskiego kat. A (USD) 3652.0 11.753738 2.211537 7.00 9.7800 11.410 13.7100 16.01
Pekao Zrównowa¿ony Rynku Amerykañskiego kat. E (PLN) 3652.0 39.280208 11.788060 18.96 28.5800 36.930 51.4600 63.37
Pekao Zrównowa¿ony Rynku Amerykañskiego kat. I (PLN) 3652.0 26.604521 4.834199 19.21 22.0175 27.180 30.7500 37.88
Pekao Zrównowa¿ony Rynku Amerykañskiego kat. I (USD) 3652.0 8.121394 1.055152 5.27 7.2200 8.120 8.9400 10.34
Pekao Zrównowa¿ony kat. A (PLN) 6632.0 113.925418 38.037180 10.00 95.1250 116.160 130.2500 217.21
Pekao Zrównowa¿ony kat. E (PLN) 4482.0 145.363139 26.019266 97.17 128.5725 139.895 161.2575 229.09
Pekao Zrównowa¿ony kat. I (PLN) 4481.0 145.848141 25.037865 96.88 129.3700 143.070 159.6200 225.36

Wykresy skrzypcowe dla danych

In [70]:
[box_plots(data, col) for col in data.funds_name.unique()]
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
c:\users\user\anaconda3\envs\tf\lib\site-packages\ipykernel_launcher.py:5: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  """
Out[70]:
[None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None]

Na poniższych wykresach zaprezentowano działnie modelu

  • na niebiesko zaznaczono obserwacje nie wchodzÄ…ce w skÅ‚ad obserwacji odstajÄ…cych
  • na pomaraÅ„czowo obserwacje odstajÄ…ce
In [71]:
[scatter_plt(data, col) for col in data.funds_name.unique()]
Out[71]:
[None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None,
 None]
In [ ]: